Overview
What is Amazon Aurora?
Amazon Aurora is a global-scale relational database service built for the cloud with full MySQL and PostgreSQL compatibility.
Great, intuitive and a must have with larger businesses
AWS Aurora Review
Great resource for product that requires great scalability with high availability
Excellent low maintenance and self administration qualities with Amazon Aurora DB.
Amazon Aurora: Empowering Scalability and Performance for Modern Database Management.
A powerful RDBMS
Amazon Aurora Internals
Aurora Serverless is the perfect database as a service in scalability if you do not want headaches or waste time managing databases.
For its easy scalability, …
Best Serverless computing platform.
Cost effective
- Primarily use it in our core payments platform given that we need strong ACID properties but we’re looking to transition to dynamodb soon …
Amazon Aurora - what an excellent solution for Database problems
Migrating your databases to Amazon Aurora to reduce Storage Costs
Even better than Amazon RDS
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Automated backups (25)9.595%
- Database scalability (26)9.494%
- Automatic software patching (26)8.989%
- Monitoring and metrics (25)8.787%
Reviewer Pros & Cons
Features
Database-as-a-Service
Database as a Service (DBaaS) software, sometimes referred to as cloud database software, is the delivery of database services ocer the Internet as a service
- 8.9Automatic software patching(26) Ratings
Patches applied to database automatically
- 9.4Database scalability(26) Ratings
Ease of scaling compute or memory resources and storage up or down
- 9.5Automated backups(25) Ratings
Automated backup enabling point-in-time data recovery
- 9.2Database security provisions(24) Ratings
Provision for database encryption, network isolation, and identity access management
- 8.7Monitoring and metrics(25) Ratings
Built-in monitoring of multiple operational metrics
- 9.1Automatic host deployment(23) Ratings
Compute instance replacement in the event of hardware failure
Service Offering Details
- About
- Integrations
- Competitors
- Tech Details
- FAQs
What is Amazon Aurora?
Amazon Aurora features a distributed, fault-tolerant, self-healing storage system that auto-scales up to 64TB per database instance. It delivers performance and availability with up to 15 low-latency read replicas, point-in-time recovery, continuous backup to Amazon S3, and replication across three Availability Zones (AZs).
The vendor invites readers to learn more details on how they designed Amazon Aurora, from AWS CTO, Werner Vogels.
Amazon Aurora Screenshots
Amazon Aurora Videos
Amazon Aurora Supported Products
Amazon Aurora Competitors
Amazon Aurora Availability
Geography | NAMER, EMEA, APAC, LATAM |
---|---|
Supported Languages | English, French, Chinese, Korean, Japanese |
Frequently Asked Questions
Comparisons
Compare with
Reviews and Ratings
(160)Attribute Ratings
Reviews
(1-25 of 30)AWS Aurora Review
- High Availability and Fault Tolerance
- High Performance
- Backup and Restore feature
- It has a limited support for non-SQL/PostgreSQL engines
- More integration with other AWS services
Excellent low maintenance and self administration qualities with Amazon Aurora DB.
- Scalability
- Enable and disable database as needed
- Database administration
- Training and examples for vairoud use cases
Amazon Aurora: Empowering Scalability and Performance for Modern Database Management.
- High availability.
- Compatibility.
- High throughput.
- Cost
- Complexity
A powerful RDBMS
It has a powerful life of taking a huge amounts of data, as for long I have been working with data, I wanted a powerful and well working database system for working efficiently and effectively with my data works, well this application has a cool and powerful chain system for making relationships with various data. I loved it.
- Powerful data handling
- Migration facility
- Cost effective application
- GUI
- Interaction
Amazon Aurora Internals
- High performance
- high availability
- scalability
- Limited Availability of Compatibility Versions
- Complexity in Cross-Region Replication
- Storage Scaling Limitations
Best Serverless computing platform.
- Able to work on very big databases without any interruptions.
- One of the best things about Aurora is everything is hosted in the cloud with wider capabilities.
- It is easy to implement, and the interface is easy to access.
- Very quick instances can be connected without the loss of data.
- Its interface is quite simple but repetitive in nature.
- Database authentication problems can be improved.
- Sometimes logical errors occur which is annoying in nature.
Cost effective
- Primarily use it in our core payments platform given that we need strong ACID properties but we’re looking to transition to dynamodb soon given that dynamodb also has transaction semantics
- It is our de facto database for starting any new microservice
- Cost effective relational database
- High availability in multiple regions
- Fully managed
- I/O costs are incurred
- Not fully MySQL compatible especially if you’re using something very specific to mysql
- Might hit the upper limit on max number of connections
- Great for when you need ACID/strong transaction semantics, dealing with financial data or anything structured
- As you keep scaling beyond sharding/partitioning particularly for unstructured data it makes sense to start exploring NoSql/DynamoDb for your needs as somethings like scaling are achieved automatically with dynamodb. It’s sort of like have a dial where you can scale up or down based on the needs of your system.
Amazon Aurora - what an excellent solution for Database problems
- No need to provision storage nor IOPS for the disks
- Automatics continuos backups with the possibility to point-in-time restore in new database or backtrack to a point in time in the same database
- Increase availability by using Read Replicas and also distributing read capacity using them for queries
- If using Aurora Serverles v2 one thing missing is the possibility to reduce it to 0 ACU
You simply will have to connect to the dabase and take care of the data.
Migrating your databases to Amazon Aurora to reduce Storage Costs
- Efficient monitoring of databases such as SQL, etc.
- Fully automatic scaling
- Fully encrypted backups
- Price
- Complex configurations
- Technical Support could be better
Amazing Amazon Aurora
- Data management
- Relational data
- Comparisons
- Notifications
Amazon Aurora Review
- Transactional Queries
- Storage Scale Up
- Higher Performance
- Compatibility with Mysql
- Super Easy Cluster Mode setup
- On the fly DB Vertical Scaling could be useful
- Connection Display & stats can be present to see and improve app design
2. Hosting a Web App
3. Storage of Structured Data
- 100% Uptime with no packet losses
- Scalability with read replicas
- fully managed database
- Restore Point in Time
- Handel more load than mysql
- Parallel Queries supported
- Improve Response time
- Add write replica for scaling
- database caching
- Online Gaming Platforms
- High Traffic Websites - Websites and web applications with heavy traffic loads can benefit from Aurora's scalability and read/write performance, ensuring responsive user experiences even during peak traffic times.
- E-Commerce Platforms
- Content Management Systems (CMS)
- Analytical and Reporting Workloads - Organizations performing complex analytical queries and generating reports from large datasets can benefit from Aurora's performance optimizations and compatibility with popular reporting tools.
Resource Manager/Recruiter
- Provides continuous backups while other applications are running without causing any interruption in production.
- Provides built-in security features i.e. encryption at rest and in-transit, making sure that our data is secure both during storage and transmission.
- Allows us to easily monitor the database's performance metrics and analyze them to optimize query performance and identify any potential issues.
- Improve the ability to handle time zone conversions and daylight saving time.
- Geospatial data is becoming increasingly important in various applications, and Aurora currently lacks built-in support for geospatial data types and functions.
- I think allowing and enchancing schema changes would improve the overall database management experience.
It is an amazing service!
- Integration and Deployment
- Service and Support
- Product Capabilities
- Security
- Better price
- Good documentation
- High availability
Best performance, at a cost
- High-availability
- Multi-AZ configuration
- Serverless support
- Crash recovery
- Asynchronous replication lag
- Opaque pricing
Exceeds expectation when using Amazon Aurora
- Scale Relational database
- integration with cloudwatch helps with monitoring the database efficiently
- Autoscaling of Aurora clusters
- max connections
- loading data from S3 bucket
- database cloning
Amazon Aurora Review
- Collect date
- Aggregate data
- Sort data
- Sequence data
- Customer service
- Accessibility
- Functionality
Amazon Aurora - A Boost on Standard MySQL
- Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
- Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
- Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases
- The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
- Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
- Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
Aurora is a great managed sql service by AWS
- Automatic scaling of read replicas
- Quick vertical scaling of server size
- Scaling metrics to determine the right time to scale for cost efficiency
- Self updates
- Better explanations of configuration settings
- Easier error logging when failovers are required
- More information on best practices for common scenarios like when database size gets too big or queries slow down
- Auto-expansion of the disks. The administrators don't have to worry about disk sizes anymore.
- Default configuration sets are designed for the majority of the OLTP use-cases. As a developer, I don't have to worry about tuning the MySQL configurations anymore.
- Better Performance than MySQL hosted on EC2 instances. The Aurora architecture allows faster replication as well.
- Access to slow query, and error logs is a little cumbersome. Maybe, stream that to an AWS Elasticsearch, and provide searching out of the box (even if it means additional costs).
- Upgrade to higher versions of MySQL is a problem.
- Failovers to replica, although, they are not needed often, they can be made more seamless.
Less Appropriate: It can be a bit pricey. If you are operating under a budget, this may not be the right tool. RDS is slightly cheaper than Aurora. Configurations and documentation can be confusing at times, but if you have access to the AWS Solution Architects, it gets easier.
- Compatible with MySQL
- Storage space management
- Cross platform
- Fail proof
- The storage space is increased from 64 TiB to 128 but still, it is not enough for large organizations.
- Compatibility issues with older MySQL.
- MySQL features, like the MyISAM storage engine is missing.
Old Database New Again: AWS Aurora, and it Shines
- Aurora stands out in clustering (or multi-zone high availability) provided out of the box
- DBA-less (almost) solution, at least the server-side aspect is muted, no patching or any hardening to make
- Scale horizontally or vertically, or both.
- The serverless option is attractive for ad-hoc use
- Read-only replicas for robust analytics
- Easy of programmability, supported by most drivers immediately
- Easy scaling - can be either horizontal and/or vertical.
- Nearly seamless backups, easy management.
- 0 worries about server-side security.
- Secondaries: up to 15 read-only replicas are enough even for very analytics hungry enterprises plus it makes all the data immutable.
- Speed: it is hard to say 100% accurately, but in my view, Aurora beats all in the cost to speed ratio.
- The Small and Medium instances are only good for testing or development, the number of connections and resources is limited.
- The 5.7 as the latest version of AWS Aurora in MySQL compatibility is behind feature-wise to what the most recent release of MySQL offers (the same applies to Postgres mode).
- Some odd or sub-optimal configuration values with some parameters not changeable.
- No online development experience. So one must rely on Open Source tooling that is typically subpar to commercial offerings which in turn often are pricey and requires a desktop environment. I wish AWS Cloud 9 could offer in the Cloud Aurora development.
- Completely DBA-less (or nearly so)
- Can replace most RDBMs
- Ideal for fast-growing companies or those that need to scale out and back. This is not so easy with say NoSQL or Hadoop-based products
- For most programmers or database developers, starting to code against MySQL is an easy thing, most mature programming languages have a native driver, MySQL shell
- Good enough for simple analytics as enterprise reporting, so it can forfeit the need for a dedicated data mart or even a data warehouse
- Can be ~ 20% costlier than just a self-managed MySQL instance
- Outdated version-wise compared to where Oracle's MySQL is
- As a result of the older version used some analytical functionality is beyond reach for ordinary developers or analysts or requires the use of mature commercial tools
- High availability
- Fault tolerance
- Back up and restore
- Open source database compatibility
- Pricing: indeed there is a premium for using Aurora but the cost is worth the benefit of minimizing the time spent tending database infrastructure.
Very happy with Aurora, especially operationally.
- Adding and removing reader nodes is seamless
- Failover is fast
- Low replication delay on reader nodes
- Some quirks exist with corner case behaviors. e.g. we had some perf issues with GIN indexes.
- A little slow to provide the latest Postgres versions. We'd love to use Postgres 12.
- The endpoints are ok, but we end up implementing our own to better meet our use cases.
- Best practices incur additional data transfer costs. I would expect those not to be charged.
Amazon Aurora is the database to lookout for in the future
- It is a high performance and low latency database. You can also be assured of the high-availability of the database and the services hosted.
- The Security provided by Amazon is again top notch because all of the data is encrypted and secured. The customers feel much more relaxed and assured when the project is using Amazon Aurora to host their services.
- A big plus point for Amazon Aurora is the latest and impactful upgrades which it brings in the package. The automated up-gradation and maintenance is an outstanding feature which it provides to receive and stay up to date with the latest upgrades in the DB world.
- It is compatible with MySQL and PostgreSQL. It essentially means that the database is able to support the old data-sets and tools which were being used on those DB's. This is a great advantage because it is essentially backward compatible.
- The Amazon technical team behind the development of this software is very knowledgeable and supportive as well. We told our requirements clearly and they suggested the best use of the database for us, which scenario it should be used, and which it is not a perfect fit.
- I think the biggest point for a project or team to consider is the cost. Although it can scale and descale according to your requirements, still you need to be cautious and have a vision of how big your database is going to be, how complex it is going to be, and how much does latency matter. You need to factor all those decisions before going to spend extra on Amazon Aurora as compared to a simple MySQL database.
- It suffers from Clod start which is a very well known aspect of the product. But the recovery part is also not up to the mark. They need to improve on the ability to restore a copy of the backup, but mostly it is seen that the copy is corrupted or not the latest one.
- It does allow us to add new nodes to the existing cluster but we need to be wary of that the new nodes are read-only nodes. All the functions of write/update will still be carried out by the master node only.